ExternalDepositoryTenderHistory(Superceded)

Entity Definition

Logical Name : ExternalDepositoryTenderHistory(Superceded)
Physical Name : LE_HST_EXTDST_TND

An accumulator for various tender amounts and units held and transferred to an EXTERNAL REPOSITORY. These totals cover an accumulation period bounded by the EXTERNAL REPOSITORY SETTLEMENT TRANSACTION.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
TransactionID (FK)(PK) A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. ID_TRN IdentityUUID char(32) ExternalDepositoryDocument(LE_HST_EXTDST)
TenderRepositoryID (FK)(PK) The unique identifier for the TENDER RESPOSITORY. ID_RPSTY_TND Identity integer ExternalDepositoryDocument(LE_HST_EXTDST)
TenderTypeCode (FK)(PK) A code which uniquely identifies the type of tender, ie cash, check, credit card, etc. TY_TND Code varchar(20) Tender(AS_TND)
OpenBalanceTotalAmount The monetary amount of the opening balance of TENDER in the EXTERNAL DEPOSITORY at the start of the external depository settlement period. MO_BLNC_OPN Money decimal(16,5)
DepositTotalAmount The total amount of tender deposited in the EXTERNAL DEPOSITORY for each external depository settlement period. MO_DS_TND Money decimal(16,5)
TotalTenderDepositCount The total number of TENDER deposits made in the EXTERNAL DEPOSITORY for each external depository settlement period. QU_DS_TND_TOT QuantityTransactionCount decimal(7,0)
DepositDateTimestamp The timestamp when tender is deposited in the EXTERNAL DEPOSITORY for each external depository settlement period. TS_DS_TND AuditDateTime datetime
ReceiptTotalAmount The total amount of money received from the EXTERNAL DEPOSITORY in each external depository settlement period. MO_RCV_TND_TOT Money decimal(16,5)
TotalTenderReceiptCount The total number of receipts to the STORE from the EXTERNAL DEPOSITORY in each external depository settlement period. QU_RCV_TND_TOT QuantityTransactionCount decimal(7,0)
UnderTenderDiscrepancyAmount The shortage, expressed as an amount, between the actual and recorded tender deposited in the EXTERNAL DEPOSITORY for external depository settlement period. MO_DSCP_TND_UND Money decimal(16,5)
OverTenderDiscrepancyAmount The overage, expressed as an amount, between the actual and recorded tender deposited in the EXTERNAL DEPOSITORY for external depository settlement period. MO_DSCP_TND_OVR Money decimal(16,5)
TotalTenderCountedAmount The actual tender monetary value counted as part of the settlement process. MO_TOT_TND__CNT_AMT Money decimal(16,5)

Relationships

Parent Entity Verb Phrase Child Entity
Tender is tracked by ExternalDepositoryTenderHistory(Superceded)
ExternalDepositoryDocument may include ExternalDepositoryTenderHistory(Superceded)

No Logical Views for ExternalDepositoryTenderHistory(Superceded)